( 1 ) designing and assigning the tablespace and bufferpool and adopting appropriately correlative optimization method and technique to optimize the performance of the system practically . ( 2 ) optimizing the data dictionary , parts of sources code sql sentence and parametric query optimization . ( 3 ) adjusting and improving record parameter , performance parameter and application parameter which affect the performance of the system primary 最后,結(jié)合某人力資源管理信息系統(tǒng),采用相關(guān)的優(yōu)化技術(shù)和技巧,進行一些實例優(yōu)化: ( 1 )重新設(shè)計、分配表空間和緩沖池,適當(dāng)采用反規(guī)范化設(shè)計優(yōu)化和增建索引; ( 2 )對字典表,部分源代碼sql語句和參數(shù)查詢進行優(yōu)化; ( 3 )對主要影響應(yīng)用系統(tǒng)性能的日志參數(shù)、性能參數(shù)和應(yīng)用程序參數(shù)進行調(diào)優(yōu)設(shè)置和改進;通過這一系列的優(yōu)化改進,使得該應(yīng)用系統(tǒng)性能得到了提高;取得了良好使用效果,具有較高的實用價值。